Christian G. ✭✭✭✭✭✭

Overview

Overview

Roles	Member
Badges	12

About Me

About Me

Area of Expertise	Automation
About Me	Smartsheet Self taught
How I Use Smartsheet	Everyday, for everything

Analytics

111

Posts

165

Visits

1.3k

Points

Sep 14, 2022

Join Date

Oct 26, 2023

Last Active

Reactions

• Insightful 2

  2
• Vote Up 23

  23
• Awesome 12

  12

• Activity
• Discussions5
• Comments106

• Re: SUMIFS/COUNTIFS Date Issue

  Christian G.

  11/02/22
  It seems that you compare a whole date vs a month {Term from Roster} is a date MONTH(TODAY())-1 is a number from 0 to 11 You should compare MONTH({Term from Roster}) to MONTH(TODAY()-1) Also, MONTH(T…
  1 ·

• Re: is there a way to enter a number that shows up as a text?

  Christian G.

  11/02/22
  To enter a number as text, Try this " '1 " and I don't understand the rest of the question.
  1 ·

• Re: Automated reminders

  Christian G.

  11/02/22
  Assuming that your column are configure as followed : "Date Submitted" -> Date "Submitted by" -> Contact list "Personal Charges Paid (Y/N)" - Check box Beware that…
  1 ·

• Re: IF(COUNTIFS......Help Request

  Christian G.

  11/02/22
  =IF(COUNTIFS({Client}, Client@row, {Due Date}, <TODAY(), {Deliverable}, <>"",{Status},<>"Waiting on Client") = 0, "", COUNTIFS({Client}, Client@row, {Due …
  1 ·

• Re: Sum formula not working

  Christian G.

  10/20/22
  It is interpreting the cells as String and not there value. Try this: Chage the "IF " satatement. Instead of IF(AND([Price Type]@row = "Regular", [23rd Total Radiology 30 Jan - 2 …
  1 ·

Previous Next